﻿CREATE TABLE [dbo].[PolitaAsigurare] (
    [IDPolitaAsigurare] INT          IDENTITY (1, 1) NOT NULL,
    [Serie]             VARCHAR (10) CONSTRAINT [DF_PolitaAsigurare_Serie] DEFAULT ('') NOT NULL,
    [Numar]             DECIMAL (18) CONSTRAINT [DF_PolitaAsigurare_Numar] DEFAULT ((0)) NOT NULL,
    [DataValabilitate]  DATETIME     NOT NULL,
    [SocAsigurare]      VARCHAR (50) CONSTRAINT [DF_PolitaAsigurare_SocAsigurare] DEFAULT ('') NOT NULL,
    [IDPersoana]        INT          CONSTRAINT [DF_PolitaAsigurare_IDPersoana] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_PolitaAsigurare] PRIMARY KEY CLUSTERED ([IDPolitaAsigurare] ASC)
);

